<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>技术文章  /  sqlserver_sharncode.com - 分享技术分享成就 - 为广大编程开发人员提供资源分享、交流学习的技术性网站</title>

<meta name="keywords" content="" />

<meta name="description" content="" />

<link href="/templets/style/dedecms.css" rel="stylesheet" media="screen" type="text/css" />

</head>

<body class="articlelist">

<div class="header">
    <div class="top w960 center">
      <div class="title">
        <h1> <a href="http://www.sharncode.com">sharncode.com - 分享技术分享成就 - 为广大编程开发人员提供资源分享、交流学习的技术性网站</a> </h1>
       </div>
      <!-- /title -->
      <div class="banner"><a href="http://www.sharncode.com/"><img src="/templets/images/banner-header.png" /></a>
</div>
      <!-- /banner -->
      <div class="rlink">
        <ul>
           <li class="r2"><a href="http://www.sharncode.com/tags.php">TAG标签</a></li>
        </ul>
      </div>
      <!-- /banner -->
    </div>
    <!-- /top -->
    <div class="nav mt1">
      <div class="w960 center">
        <ul>
          <li><a href='/'>主页</a></li>
          
          <li><a href='http://www.sharncode.com/html/itnews/index.html'>业内资讯</a></li><li class='thisclass'><a href='/html/articles/index.html'>技术文章</a> </li>
          <li><a href='http://www.sharncode.com/ask'>编程问答</a></li>
          <li><a href='http://www.sharncode.com/thestory/index.html'>程序人生</a></li>
          <li><a href='http://www.sharncode.com/thosethings/index.html'>网络那些事</a></li>
          <li><a href='http://www.sharncode.com/docdown/index.html'>文档下载</a></li>
          <li><a href='http://www.sharncode.com/bookdown/index.html'>书籍下载</a></li>
          <li><a href='http://www.sharncode.com/software/index.html'>软件下载</a></li>
          <li><a href='http://www.sharncode.com/codedown/index.html'>源码下载</a></li>
          <li><a href='http://www.sharncode.com/onlinedoc/index.html'>在线文档</a></li>
        </ul>
      </div>
    </div>
    <!-- /nav -->
    <div class="search">
      <div class="w960 center">
      <form action="/plus/search.php" name="formsearch">
        <div class="form">
          <h4>搜索</h4>
           <input type="hidden" name="kwtype" value="0" />
           <input name="keyword" type="text" class="search-keyword" id="search-keyword" />
           <select name="searchtype" class="search-option" id="search-option">
               <option value="titlekeyword" selected='1'>智能模糊搜索</option>
               <option value="title">仅搜索标题</option>
           </select>
          <button type="submit" class="search-submit">搜索</button>
        </div>
        </form>
        <!-- /form -->
        <div class="tags">
          <h4>热门标签</h4>
          <ul>
          <li><a href='http://www.sharncode.com/tags.php?/dedecms/' target="_blank">dedecms</a></li>
          <li><a href='http://www.sharncode.com/tags.php?/extjs%E6%A1%86%E6%9E%B6/' target="_blank">extjs框架</a></li>
          <li><a href='http://www.sharncode.com/tags.php?/Ext3.2%E4%B8%AD%E6%96%87API/' target="_blank">Ext3.2中文API</a></li>
          <li><a href='http://www.sharncode.com/tags.php?/%E6%96%87%E6%A1%A3%E4%B8%8B%E8%BD%BD/' target="_blank">文档下载</a></li>
          <li><a href='http://www.sharncode.com/tags.php?/ext+2+AP/' target="_blank">ext 2 AP</a></li>
          <li><a href='http://www.sharncode.com/tags.php?/I%E8%8B%B1%E6%96%87%E5%8E%9F%E7%89%88/' target="_blank">I英文原版</a></li>
          <li><a href='http://www.sharncode.com/tags.php?/Ext3.0%E4%B8%AD%E6%96%87API/' target="_blank">Ext3.0中文API</a></li>
          <li><a href='http://www.sharncode.com/tags.php?/jQuery+1.4/' target="_blank">jQuery 1.4</a></li>
          
          </ul>
        </div>
        <!-- /tags -->
      </div>
    </div>
    <!-- /search -->
  </div>
<!-- /header -->

<!-- /header -->



<div class="channel-nav w960 center clear">

	<ul>

              

          <li><a href='http://www.sharncode.com/html/articles/asp_net/index.html'><span>asp.net</span></a></li><li class='thisclass'><a href='/html/articles/sqlserver/index.html'><span>sqlserver</span></a> </li>

          <li><a href='http://www.sharncode.com/html/articles/php/index.html'><span>php</span></a></li>

          <li><a href='http://www.sharncode.com/html/articles/mysql/index.html'><span>mysql</span></a></li>

          <li><a href='http://www.sharncode.com/html/articles/java/index.html'><span>java</span></a></li>

          <li><a href='http://www.sharncode.com/html/articles/setup/index.html'><span>配置安装</span></a></li>

	</ul>

	<span class="back">

		<a href="'http://www.sharncode.com/">返回首页</a>

	</span>

</div><!-- /channel-nav -->



<div class="w960 center clear mt1">

	<div class="pleft">

		<div class="place">

			<strong>当前位置:</strong> <a href='http://www.sharncode.comhttp://localhost:50081'>首页</a> > <a href='/html/articles/index.html'>技术文章</a> > <a href='/html/articles/sqlserver/index.html'>sqlserver</a> > 

		</div><!-- /place -->

		<div class="listbox">

			<ul class="e2">

<li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/31.html" class="title" target="_blank"><b>sql server导出txt文件 2种方式 BCP命令</b></a>

					<span class="info">

						<small>日期：</small>2012-03-28 22:44:17

						<small>点击：</small>3

						<small>好评：</small>0

					</span>

					<p class="intro">

						--逗号分割导出 exec master..xp_cmdshell 'bcp shangdu.dbo.shang_cms_caiji out d:\tt.txt -c -t , -U sa -P 123456' --txt导出 exec master..xp_cmdshell 'bcp select * from shangdu.dbo.shang_cms_caiji queryout d:\tt.txt -c -t -Usa -P123456...

					</p>

				</li><li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/18.html" class="title" target="_blank">sql server 删除清空日志 压缩数据库</a>

					<span class="info">

						<small>日期：</small>2012-01-11 19:59:37

						<small>点击：</small>6

						<small>好评：</small>350

					</span>

					<p class="intro">

						1: 删除LOG 1：分离数据库 企业管理器－＞服务器－＞数据库－＞右键－＞分离数据库 2：删除LOG文件 3：附加数据库 企业管理器－＞服务器－＞数据库－＞右键－＞附加数据库 此法生成...

					</p>

				</li><li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/17.html" class="title" target="_blank">sql server使用sql语句查看表空间大小</a>

					<span class="info">

						<small>日期：</small>2012-01-11 19:58:13

						<small>点击：</small>5

						<small>好评：</small>355

					</span>

					<p class="intro">

						sql server使用sql语句查看表空间大小 ...

					</p>

				</li><li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/16.html" class="title" target="_blank">sql server常用sql语句添加删除修改字段 创建表及描</a>

					<span class="info">

						<small>日期：</small>2012-01-11 19:54:18

						<small>点击：</small>3

						<small>好评：</small>346

					</span>

					<p class="intro">

						sql server常用sql语句添加删除修改字段 创建表及描述信息...

					</p>

				</li><li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/15.html" class="title" target="_blank">sqlserver获取查询的时间 统计sql执行时间</a>

					<span class="info">

						<small>日期：</small>2012-01-11 19:53:18

						<small>点击：</small>2

						<small>好评：</small>350

					</span>

					<p class="intro">

						sqlserver获取查询的时间 统计sql执行时间...

					</p>

				</li><li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/14.html" class="title" target="_blank">SQL Server字符串处理函数大全  事务编程 存储过程</a>

					<span class="info">

						<small>日期：</small>2012-01-11 19:47:53

						<small>点击：</small>3

						<small>好评：</small>310

					</span>

					<p class="intro">

						select语句中只能使用sql函数对字段进行操作（链接sql server）， select 字段1 from 表1 where 字段1.IndexOf(云)=1; 这条语句不对的原因是indexof（）函数不是sql函数，改成sql对应的函数就可以了。...

					</p>

				</li><li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/13.html" class="title" target="_blank">sql server 系统表的信息sysobjects 查询sql 2000系统数</a>

					<span class="info">

						<small>日期：</small>2012-01-11 19:43:47

						<small>点击：</small>16

						<small>好评：</small>350

					</span>

					<p class="intro">

						sql server 系统表的信息sysobjects 查询sql 2000系统数据库表 视图...

					</p>

				</li><li>

					<a href="http://www.sharncode.com/html/articles/sqlserver/11.html" class="title" target="_blank">sql server 2000 数据库备份命令行 完全备份差异备份</a>

					<span class="info">

						<small>日期：</small>2012-01-11 19:36:42

						<small>点击：</small>9

						<small>好评：</small>345

					</span>

					<p class="intro">

						sql server 2k 数据库备份命令 --完全备份 BACKUP DATABASE DataEx TO DISK = 'd:\dbBackTest.bak' --差异备份 BACKUP DATABASE DataEx TO DISK = 'd:\dbBackTest.bak' with differential --恢复完全备份 restore database test from di...

					</p>

				</li>

			</ul>

		</div><!-- /listbox -->

		<div class="dede_pages">

			<ul class="pagelist">

             <span class="pageinfo">共 <strong>1</strong>页<strong>8</strong>条记录</span>

			</ul>

		</div><!-- /pages -->

	</div><!-- /pleft -->

	

	<div class="pright">

		<div class="commend">

			<dl class="tbox">

				<dt><strong>推荐内容</strong></dt>

				<dd>

					<ul class="d4">

           <li><a href="http://www.sharncode.com/html/articles/sqlserver/31.html" target="_blank">sql server导出txt文件 2种方式 BCP命令</a>

            	<p>--逗号分割导出 exec master..xp_cmdshell 'bcp shangdu.dbo.shang_cms_caiji ou...</p>

            </li>


					</ul>

				</dd>

			</dl>

		</div><!-- /commend -->

		

		<div class="hot mt1">

			<dl class="tbox">

				<dt><strong>热点内容</strong></dt>

				<dd>

					<ul class="c1 ico2">

                    <li><a href="http://www.sharncode.com/html/articles/sqlserver/13.html" target="_blank">sql server 系统表的信息sy</a></li>
<li><a href="http://www.sharncode.com/html/articles/sqlserver/11.html" target="_blank">sql server 2000 数据库备份命</a></li>
<li><a href="http://www.sharncode.com/html/articles/sqlserver/18.html" target="_blank">sql server 删除清空日志 压</a></li>
<li><a href="http://www.sharncode.com/html/articles/sqlserver/17.html" target="_blank">sql server使用sql语句查看表</a></li>
<li><a href="http://www.sharncode.com/html/articles/sqlserver/14.html" target="_blank">SQL Server字符串处理函数大</a></li>
<li><a href="http://www.sharncode.com/html/articles/sqlserver/16.html" target="_blank">sql server常用sql语句添加删</a></li>
<li><a href="http://www.sharncode.com/html/articles/sqlserver/31.html" target="_blank">sql server导出txt文件 2种方</a></li>
<li><a href="http://www.sharncode.com/html/articles/sqlserver/15.html" target="_blank">sqlserver获取查询的时间 统</a></li>


					</ul>

				</dd>

			</dl>

		</div>





	</div><!-- /pright -->

</div>



﻿<div class="footer w960 center mt1 clear">
	<!-- 
		为了支持织梦团队的发展,请您保留织梦内容管理系统的链接信息.
		我们对支持织梦团队发展的朋友表示真心的感谢!织梦因您更精彩!
		dedecms <span>V53_1_UTF8</span>
	-->
	<p class="powered">
		Powered by <a href="http://www.sharncode.com" target="_blank"><strong>dedecms</strong></a> &copy; 2004-2009 <a href="http://www.sharncode.com/" target="_blank">sharncode</a> Inc.	</p>
<!-- /powered -->
	<p class="copyright">
		Copyright &copy; 2011-2021 sharncode.com 版权所有<br />
  </p>
</div>
<script type="text/javascript">
var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://");
document.write(unescape("%3Cscript src='" + _bdhmProtocol + "hm.baidu.com/h.js%3F5dc59cbd80a32869d4430a8ad1c505bb' type='text/javascript'%3E%3C/script%3E"));
</script>


<!-- /footer -->



</body>

</html>

